# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月17日
"""
import openpyxl

myBook = openpyxl.load_workbook('五百强企业表.xlsx')
mySheet=myBook['五百强企业表']
myRows=list(mySheet.values)[1:]
mySet=set()
for myRow in myRows:
	for myName in myRow[1:]:
		# print(myName)
		mySet.add(myName)

print(mySet)
myNewSheet=myBook.create_sheet('所有公司表')
for myName in mySet:
	myNewSheet.append([myName])

myBook.save('结果表-世界五百强公司.xlsx')
